HTML_CleanNumber

Cleans block of string (HTML block) from characters that are not needed Can ...

Excel clipboard bug

Looks like there is a bug in Excel when dealing with copy and paste. Excel ...

O365 Blocked Macros

Recent Microsoft 365 Excel blocked macros from running when they are in ...

Dropdown button commands

A drop-down of multiple commands in pure VBA. Needed this in a large Excel-VBA ...

DropdownButton.zip

CreateUniqueList

Create list of unique items from a column into another column This is similar ...

AutoSaveOn

Automatically save workbook (when using OneDrive) on or off This is the VBA ...

GetGroupMembers

List All the Members of a Group Needs GroupNames text file having list of ...

GetGroupMembers.zip

RowList_Matching

Returns list of rows numbers having cells matching text in a column. Passing ...

NMRRank_v2021

Ranks a number among set of numbers. This is part of huge tool, we needed to ...

Frm6 - ANmaMultiSelect

Give users ability to multi-select from list of items into cells with separator. ...

Frm6.zip

Execute exe embedded in Excel

Execute exe file that embed inside Excel sheet This is for experimental, not ...

ShapeRange_BG

Replaces the background fill of any shape in Excel with an image Not Ready yet, ...